<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
 "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
	<title>数据结构</title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<meta name="date" content="Fri, 22 Dec 2017 14:22:23 +0800">
	<meta name="generator" content="MySQL-Front 5.3  (Build 4.234)">
	<style type="text/css"><!--
		body {font-family: Arial,Helvetica,sans-serif; font-size: 16px;}
		h1 {font-size: 22px; text-decoration: bold;}
		h2 {font-size: 20px; text-decoration: bold;}
		h3 {font-size: 18px; text-decoration: bold;}
		th,
		td {font-size: 16px; border-color: #000000; border-style: solid; border-width: 1px; padding: 1px; font-weight: normal;}
		code {font-size: 16px;}
		.TableObject {border-collapse: collapse; border-color: #000000; font-family: Consolas}
		.TableData {border-collapse: collapse; border-color: #000000; font-family: Consolas}
		.TableHeader {border-color: #000000; text-decoration: bold; background-color: #e0e0e0;}
		.StructureHeader {padding-left: 5px; text-align: left; border-color: #000000; text-decoration: bold;}
		.Structure {text-align: left; border-color: #aaaaaa;}
		.odd {}
		.even {}
		.DataHeader {padding-left: 5px; text-align: left; border-color: #000000; background-color: #e0e0e0;}
		.Null {color: #999999;}
		.PrimaryKey {font-weight: bold;}
		.RightAlign {text-align: right;}
	--></style>
</head>
<body>
<h1 class="DatabaseTitle">数据库: tpshop</h1>
<h2>表格: tp_account_log</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_account_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>log_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >user_id</td><td>user_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_account_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">log_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>日志id</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>user_money</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>用户金额</td>	</tr>
	<tr class="Structure"><td>frozen_money</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>冻结金额</td>	</tr>
	<tr class="Structure"><td>pay_points</td><td>mediumint(9)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>支付积分</td>	</tr>
	<tr class="Structure"><td>change_time</td><td>int(10) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>变动时间</td>	</tr>
	<tr class="Structure"><td>desc</td><td>varchar(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>描述</td>	</tr>
	<tr class="Structure"><td>order_sn</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>订单编号</td>	</tr>
	<tr class="Structure"><td>order_id</td><td>int(10)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>订单id</td>	</tr>
</table><br>
<h2>表格: tp_ad</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_ad" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>ad_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >enabled</td><td>enabled</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >position_id</td><td>pid</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_ad" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">ad_id</td><td>int(11) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>广告id</td>	</tr>
	<tr class="Structure"><td>pid</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>广告位置ID</td>	</tr>
	<tr class="Structure"><td>media_type</td><td>tinyint(3) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>广告类型</td>	</tr>
	<tr class="Structure"><td>ad_name</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>广告名称</td>	</tr>
	<tr class="Structure"><td>ad_link</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>链接地址</td>	</tr>
	<tr class="Structure"><td>ad_code</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>图片地址</td>	</tr>
	<tr class="Structure"><td>start_time</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>投放时间</td>	</tr>
	<tr class="Structure"><td>end_time</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>结束时间</td>	</tr>
	<tr class="Structure"><td>link_man</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>添加人</td>	</tr>
	<tr class="Structure"><td>link_email</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>添加人邮箱</td>	</tr>
	<tr class="Structure"><td>link_phone</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>添加人联系电话</td>	</tr>
	<tr class="Structure"><td>click_count</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>点击量</td>	</tr>
	<tr class="Structure"><td>enabled</td><td>tinyint(3) unsigned</td><td>否</td><td>1</td><td>&nbsp;</td><td>是否显示</td>	</tr>
	<tr class="Structure"><td>orderby</td><td>smallint(6)</td><td>是</td><td>50</td><td>&nbsp;</td><td>排序</td>	</tr>
	<tr class="Structure"><td>target</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否开启浏览器新窗口</td>	</tr>
	<tr class="Structure"><td>bgcolor</td><td>varchar(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>背景颜色</td>	</tr>
</table><br>
<h2>表格: tp_ad_position</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_ad_position" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>position_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_ad_position" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">position_id</td><td>int(3) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>position_name</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>广告位置名称</td>	</tr>
	<tr class="Structure"><td>ad_width</td><td>smallint(5) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>广告位宽度</td>	</tr>
	<tr class="Structure"><td>ad_height</td><td>smallint(5) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>广告位高度</td>	</tr>
	<tr class="Structure"><td>position_desc</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>广告描述</td>	</tr>
	<tr class="Structure"><td>position_style</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>模板</td>	</tr>
	<tr class="Structure"><td>is_open</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>0关闭1开启</td>	</tr>
</table><br>
<h2>表格: tp_admin</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_admin" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>admin_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >agency_id</td><td>agency_id</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >user_name</td><td>user_name</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_admin" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">admin_id</td><td>smallint(5) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>user_name</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>用户名</td>	</tr>
	<tr class="Structure"><td>email</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>email</td>	</tr>
	<tr class="Structure"><td>password</td><td>varchar(32)</td><td>否</td><td></td><td>&nbsp;</td><td>密码</td>	</tr>
	<tr class="Structure"><td>ec_salt</td><td>varchar(10)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>秘钥</td>	</tr>
	<tr class="Structure"><td>add_time</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>添加时间</td>	</tr>
	<tr class="Structure"><td>last_login</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>最后登录时间</td>	</tr>
	<tr class="Structure"><td>last_ip</td><td>varchar(15)</td><td>否</td><td></td><td>&nbsp;</td><td>最后登录ip</td>	</tr>
	<tr class="Structure"><td>nav_list</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>权限</td>	</tr>
	<tr class="Structure"><td>lang_type</td><td>varchar(50)</td><td>否</td><td></td><td>&nbsp;</td><td>lang_type</td>	</tr>
	<tr class="Structure"><td>agency_id</td><td>smallint(5) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>agency_id</td>	</tr>
	<tr class="Structure"><td>suppliers_id</td><td>smallint(5) unsigned</td><td>是</td><td>0</td><td>&nbsp;</td><td>suppliers_id</td>	</tr>
	<tr class="Structure"><td>todolist</td><td>longtext</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>todolist</td>	</tr>
	<tr class="Structure"><td>role_id</td><td>smallint(5)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>角色id</td>	</tr>
</table><br>
<h2>表格: tp_admin_log</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_admin_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>log_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_admin_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">log_id</td><td>bigint(16) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>admin_id</td><td>int(10)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>管理员id</td>	</tr>
	<tr class="Structure"><td>log_info</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>日志描述</td>	</tr>
	<tr class="Structure"><td>log_ip</td><td>varchar(30)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>ip地址</td>	</tr>
	<tr class="Structure"><td>log_url</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>url</td>	</tr>
	<tr class="Structure"><td>log_time</td><td>int(10)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>日志时间</td>	</tr>
</table><br>
<h2>表格: tp_admin_role</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_admin_role" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>role_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_admin_role" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">role_id</td><td>smallint(6) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>角色ID</td>	</tr>
	<tr class="Structure"><td>role_name</td><td>varchar(30)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>角色名称</td>	</tr>
	<tr class="Structure"><td>act_list</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>权限列表</td>	</tr>
	<tr class="Structure"><td>role_desc</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>角色描述</td>	</tr>
</table><br>
<h2>表格: tp_area_region</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_area_region" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>shipping_area_id, region_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_area_region" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">shipping_area_id</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>物流配置id</td>	</tr>
	<tr class="Structure"><td class="PrimaryKey">region_id</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>地区id对应region表id</td>	</tr>
</table><br>
<h2>表格: tp_article</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_article" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>article_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >cat_id</td><td>cat_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_article" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">article_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>cat_id</td><td>smallint(5)</td><td>否</td><td>0</td><td>&nbsp;</td><td>类别ID</td>	</tr>
	<tr class="Structure"><td>title</td><td>varchar(150)</td><td>否</td><td></td><td>&nbsp;</td><td>文章标题</td>	</tr>
	<tr class="Structure"><td>content</td><td>longtext</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>文章内容</td>	</tr>
	<tr class="Structure"><td>author</td><td>varchar(30)</td><td>否</td><td></td><td>&nbsp;</td><td>文章作者</td>	</tr>
	<tr class="Structure"><td>author_email</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>作者邮箱</td>	</tr>
	<tr class="Structure"><td>keywords</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>关键字</td>	</tr>
	<tr class="Structure"><td>article_type</td><td>tinyint(1) unsigned</td><td>否</td><td>2</td><td>&nbsp;</td><td>文章类型</td>	</tr>
	<tr class="Structure"><td>is_open</td><td>tinyint(1) unsigned</td><td>否</td><td>1</td><td>&nbsp;</td><td>是否开启</td>	</tr>
	<tr class="Structure"><td>add_time</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>添加时间</td>	</tr>
	<tr class="Structure"><td>file_url</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>附件地址</td>	</tr>
	<tr class="Structure"><td>open_type</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>open_type</td>	</tr>
	<tr class="Structure"><td>link</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>链接地址</td>	</tr>
	<tr class="Structure"><td>description</td><td>mediumtext</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>文章摘要</td>	</tr>
	<tr class="Structure"><td>click</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>浏览量</td>	</tr>
	<tr class="Structure"><td>publish_time</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>文章发布时间</td>	</tr>
	<tr class="Structure"><td>thumb</td><td>varchar(255)</td><td>是</td><td></td><td>&nbsp;</td><td>文章缩略图</td>	</tr>
</table><br>
<h2>表格: tp_article_cat</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_article_cat" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>cat_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_article_cat" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">cat_id</td><td>int(10) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>cat_name</td><td>varchar(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>类别名称</td>	</tr>
	<tr class="Structure"><td>cat_type</td><td>smallint(6)</td><td>是</td><td>0</td><td>&nbsp;</td><td>系统分组</td>	</tr>
	<tr class="Structure"><td>parent_id</td><td>smallint(6)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>夫级ID</td>	</tr>
	<tr class="Structure"><td>show_in_nav</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否导航显示</td>	</tr>
	<tr class="Structure"><td>sort_order</td><td>smallint(6)</td><td>是</td><td>50</td><td>&nbsp;</td><td>排序</td>	</tr>
	<tr class="Structure"><td>cat_desc</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>分类描述</td>	</tr>
	<tr class="Structure"><td>keywords</td><td>varchar(30)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>搜索关键词</td>	</tr>
	<tr class="Structure"><td>cat_alias</td><td>varchar(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>别名</td>	</tr>
</table><br>
<h2>表格: tp_brand</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_brand" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_brand" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>smallint(5) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>品牌表</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>品牌名称</td>	</tr>
	<tr class="Structure"><td>logo</td><td>varchar(80)</td><td>否</td><td></td><td>&nbsp;</td><td>品牌logo</td>	</tr>
	<tr class="Structure"><td>desc</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>品牌描述</td>	</tr>
	<tr class="Structure"><td>url</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>品牌地址</td>	</tr>
	<tr class="Structure"><td>sort</td><td>tinyint(3) unsigned</td><td>否</td><td>50</td><td>&nbsp;</td><td>排序</td>	</tr>
	<tr class="Structure"><td>cat_name</td><td>varchar(128)</td><td>是</td><td></td><td>&nbsp;</td><td>品牌分类</td>	</tr>
	<tr class="Structure"><td>parent_cat_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>分类id</td>	</tr>
	<tr class="Structure"><td>cat_id</td><td>int(10)</td><td>是</td><td>0</td><td>&nbsp;</td><td>分类id</td>	</tr>
	<tr class="Structure"><td>is_hot</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否推荐</td>	</tr>
</table><br>
<h2>表格: tp_cart</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_cart" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >session_id</td><td>session_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_cart" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>购物车表</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>session_id</td><td>char(128)</td><td>否</td><td></td><td>utf8_bin</td><td>session</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>goods_sn</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>商品货号</td>	</tr>
	<tr class="Structure"><td>goods_name</td><td>varchar(120)</td><td>否</td><td></td><td>&nbsp;</td><td>商品名称</td>	</tr>
	<tr class="Structure"><td>market_price</td><td>numeric(10,2) unsigned</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>市场价</td>	</tr>
	<tr class="Structure"><td>goods_price</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>本店价</td>	</tr>
	<tr class="Structure"><td>member_goods_price</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>会员折扣价</td>	</tr>
	<tr class="Structure"><td>goods_num</td><td>smallint(5) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>购买数量</td>	</tr>
	<tr class="Structure"><td>spec_key</td><td>varchar(64)</td><td>否</td><td></td><td>&nbsp;</td><td>商品规格key 对应tp_spec_goods_price 表</td>	</tr>
	<tr class="Structure"><td>spec_key_name</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>商品规格组合名称</td>	</tr>
	<tr class="Structure"><td>bar_code</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>商品条码</td>	</tr>
	<tr class="Structure"><td>selected</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>购物车选中状态</td>	</tr>
	<tr class="Structure"><td>add_time</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>加入购物车的时间</td>	</tr>
	<tr class="Structure"><td>prom_type</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>0 普通订单,1 限时抢购, 2 团购 , 3 促销优惠</td>	</tr>
	<tr class="Structure"><td>prom_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>活动id</td>	</tr>
	<tr class="Structure"><td>sku</td><td>varchar(128)</td><td>是</td><td></td><td>&nbsp;</td><td>sku</td>	</tr>
</table><br>
<h2>表格: tp_comment</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_comment" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>comment_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >id_value</td><td>goods_id</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >parent_id</td><td>parent_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_comment" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">comment_id</td><td>int(10) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>评论id</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>email</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>email邮箱</td>	</tr>
	<tr class="Structure"><td>username</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>用户名</td>	</tr>
	<tr class="Structure"><td>content</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>评论内容</td>	</tr>
	<tr class="Structure"><td>deliver_rank</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>物流评价等级</td>	</tr>
	<tr class="Structure"><td>add_time</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>添加时间</td>	</tr>
	<tr class="Structure"><td>ip_address</td><td>varchar(15)</td><td>否</td><td></td><td>&nbsp;</td><td>ip地址</td>	</tr>
	<tr class="Structure"><td>is_show</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>是否显示</td>	</tr>
	<tr class="Structure"><td>parent_id</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>父id</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>评论用户</td>	</tr>
	<tr class="Structure"><td>img</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>晒单图片</td>	</tr>
	<tr class="Structure"><td>order_id</td><td>mediumint(8)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>订单id</td>	</tr>
	<tr class="Structure"><td>goods_rank</td><td>tinyint(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>商品评价等级</td>	</tr>
	<tr class="Structure"><td>service_rank</td><td>tinyint(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>商家服务态度评价等级</td>	</tr>
</table><br>
<h2>表格: tp_config</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_config" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_config" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>smallint(6) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(64)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>配置的key键名</td>	</tr>
	<tr class="Structure"><td>value</td><td>varchar(512)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>配置的val值</td>	</tr>
	<tr class="Structure"><td>inc_type</td><td>varchar(64)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>配置分组</td>	</tr>
	<tr class="Structure"><td>desc</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>描述</td>	</tr>
</table><br>
<h2>表格: tp_coupon</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_coupon" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_coupon" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(8)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(50)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>优惠券名字</td>	</tr>
	<tr class="Structure"><td>type</td><td>tinyint(1)</td><td>否</td><td>0</td><td>&nbsp;</td><td>发放类型 0面额模板1 按用户发放 2 注册 3 邀请 4 线下发放</td>	</tr>
	<tr class="Structure"><td>money</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>优惠券金额</td>	</tr>
	<tr class="Structure"><td>condition</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>使用条件</td>	</tr>
	<tr class="Structure"><td>createnum</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>发放数量</td>	</tr>
	<tr class="Structure"><td>send_num</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>已领取数量</td>	</tr>
	<tr class="Structure"><td>use_num</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>已使用数量</td>	</tr>
	<tr class="Structure"><td>send_start_time</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>发放开始时间</td>	</tr>
	<tr class="Structure"><td>send_end_time</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>发放结束时间</td>	</tr>
	<tr class="Structure"><td>use_start_time</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>使用开始时间</td>	</tr>
	<tr class="Structure"><td>use_end_time</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>使用结束时间</td>	</tr>
	<tr class="Structure"><td>add_time</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>添加时间</td>	</tr>
</table><br>
<h2>表格: tp_coupon_list</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_coupon_list" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_coupon_list" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(8)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>cid</td><td>int(8)</td><td>否</td><td>0</td><td>&nbsp;</td><td>优惠券 对应coupon表id</td>	</tr>
	<tr class="Structure"><td>type</td><td>tinyint(1)</td><td>否</td><td>0</td><td>&nbsp;</td><td>发放类型 1 按订单发放 2 注册 3 邀请 4 按用户发放</td>	</tr>
	<tr class="Structure"><td>uid</td><td>int(8)</td><td>否</td><td>0</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>order_id</td><td>int(8)</td><td>否</td><td>0</td><td>&nbsp;</td><td>订单id</td>	</tr>
	<tr class="Structure"><td>use_time</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>使用时间</td>	</tr>
	<tr class="Structure"><td>code</td><td>varchar(10)</td><td>是</td><td></td><td>&nbsp;</td><td>优惠券兑换码</td>	</tr>
	<tr class="Structure"><td>send_time</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>发放时间</td>	</tr>
</table><br>
<h2>表格: tp_delivery_doc</h2>
<p>备注: 发货单</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_delivery_doc" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >order_id</td><td>order_id</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >user_id</td><td>user_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_delivery_doc" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>发货单ID</td>	</tr>
	<tr class="Structure"><td>order_id</td><td>int(11) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>订单ID</td>	</tr>
	<tr class="Structure"><td>order_sn</td><td>varchar(64)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>订单编号</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>int(11) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>用户ID</td>	</tr>
	<tr class="Structure"><td>admin_id</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>管理员ID</td>	</tr>
	<tr class="Structure"><td>consignee</td><td>varchar(64)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>收货人</td>	</tr>
	<tr class="Structure"><td>zipcode</td><td>varchar(6)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>邮编</td>	</tr>
	<tr class="Structure"><td>mobile</td><td>varchar(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>联系手机</td>	</tr>
	<tr class="Structure"><td>country</td><td>int(11) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>国ID</td>	</tr>
	<tr class="Structure"><td>province</td><td>int(11) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>省ID</td>	</tr>
	<tr class="Structure"><td>city</td><td>int(11) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>市ID</td>	</tr>
	<tr class="Structure"><td>district</td><td>int(11) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>区ID</td>	</tr>
	<tr class="Structure"><td>address</td><td>varchar(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>地址</td>	</tr>
	<tr class="Structure"><td>shipping_code</td><td>varchar(32)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>物流code</td>	</tr>
	<tr class="Structure"><td>shipping_name</td><td>varchar(64)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>快递名称</td>	</tr>
	<tr class="Structure"><td>shipping_price</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>运费</td>	</tr>
	<tr class="Structure"><td>invoice_no</td><td>varchar(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>物流单号</td>	</tr>
	<tr class="Structure"><td>tel</td><td>varchar(64)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>座机电话</td>	</tr>
	<tr class="Structure"><td>note</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>管理员添加的备注信息</td>	</tr>
	<tr class="Structure"><td>best_time</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>友好收货时间</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>is_del</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否删除</td>	</tr>
</table><br>
<h2>表格: tp_feedback</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_feedback" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>msg_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >user_id</td><td>user_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_feedback" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">msg_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>默认自增ID</td>	</tr>
	<tr class="Structure"><td>parent_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>回复留言ID</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>用户ID</td>	</tr>
	<tr class="Structure"><td>user_name</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>msg_title</td><td>varchar(200)</td><td>否</td><td></td><td>&nbsp;</td><td>留言标题</td>	</tr>
	<tr class="Structure"><td>msg_type</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>留言类型</td>	</tr>
	<tr class="Structure"><td>msg_status</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>处理状态</td>	</tr>
	<tr class="Structure"><td>msg_content</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>留言内容</td>	</tr>
	<tr class="Structure"><td>msg_time</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>留言时间</td>	</tr>
	<tr class="Structure"><td>message_img</td><td>varchar(255)</td><td>否</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>order_id</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>msg_area</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
</table><br>
<h2>表格: tp_flash_sale</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_flash_sale" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_flash_sale" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>bigint(10)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>title</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>活动标题</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>int(10)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>参团商品ID</td>	</tr>
	<tr class="Structure"><td>price</td><td>float(10,2)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>活动价格</td>	</tr>
	<tr class="Structure"><td>goods_num</td><td>int(10)</td><td>是</td><td>1</td><td>&nbsp;</td><td>商品参加活动数</td>	</tr>
	<tr class="Structure"><td>buy_limit</td><td>int(11)</td><td>否</td><td>1</td><td>&nbsp;</td><td>每人限购数</td>	</tr>
	<tr class="Structure"><td>buy_num</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>已购买人数</td>	</tr>
	<tr class="Structure"><td>order_num</td><td>int(10)</td><td>是</td><td>0</td><td>&nbsp;</td><td>已下单数</td>	</tr>
	<tr class="Structure"><td>description</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>活动描述</td>	</tr>
	<tr class="Structure"><td>start_time</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>开始时间</td>	</tr>
	<tr class="Structure"><td>end_time</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>结束时间</td>	</tr>
	<tr class="Structure"><td>is_end</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否已结束</td>	</tr>
	<tr class="Structure"><td>goods_name</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>商品名称</td>	</tr>
</table><br>
<h2>表格: tp_friend_link</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_friend_link" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>link_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >show_order</td><td>orderby</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_friend_link" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">link_id</td><td>smallint(5) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>link_name</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>链接名称</td>	</tr>
	<tr class="Structure"><td>link_url</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>链接地址</td>	</tr>
	<tr class="Structure"><td>link_logo</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>链接logo</td>	</tr>
	<tr class="Structure"><td>orderby</td><td>tinyint(3) unsigned</td><td>否</td><td>50</td><td>&nbsp;</td><td>排序</td>	</tr>
	<tr class="Structure"><td>is_show</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>是否显示</td>	</tr>
	<tr class="Structure"><td>target</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>是否新窗口打开</td>	</tr>
</table><br>
<h2>表格: tp_goods</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_goods" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>goods_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >brand_id</td><td>brand_id</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >cat_id</td><td>cat_id</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >goods_number</td><td>store_count</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >goods_sn</td><td>goods_sn</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >goods_weight</td><td>weight</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >last_update</td><td>last_update</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >sort_order</td><td>sort</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_goods" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">goods_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>cat_id</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>分类id</td>	</tr>
	<tr class="Structure"><td>extend_cat_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>扩展分类id</td>	</tr>
	<tr class="Structure"><td>goods_sn</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>商品编号</td>	</tr>
	<tr class="Structure"><td>goods_name</td><td>varchar(120)</td><td>否</td><td></td><td>&nbsp;</td><td>商品名称</td>	</tr>
	<tr class="Structure"><td>click_count</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>点击数</td>	</tr>
	<tr class="Structure"><td>brand_id</td><td>smallint(5) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>品牌id</td>	</tr>
	<tr class="Structure"><td>store_count</td><td>smallint(5) unsigned</td><td>否</td><td>10</td><td>&nbsp;</td><td>库存数量</td>	</tr>
	<tr class="Structure"><td>comment_count</td><td>smallint(5)</td><td>是</td><td>0</td><td>&nbsp;</td><td>商品评论数</td>	</tr>
	<tr class="Structure"><td>weight</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品重量克为单位</td>	</tr>
	<tr class="Structure"><td>market_price</td><td>numeric(10,2) unsigned</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>市场价</td>	</tr>
	<tr class="Structure"><td>shop_price</td><td>numeric(10,2) unsigned</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>本店价</td>	</tr>
	<tr class="Structure"><td>cost_price</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>商品成本价</td>	</tr>
	<tr class="Structure"><td>keywords</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>商品关键词</td>	</tr>
	<tr class="Structure"><td>goods_remark</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>商品简单描述</td>	</tr>
	<tr class="Structure"><td>goods_content</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>商品详细描述</td>	</tr>
	<tr class="Structure"><td>original_img</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>商品上传原始图</td>	</tr>
	<tr class="Structure"><td>is_real</td><td>tinyint(3) unsigned</td><td>否</td><td>1</td><td>&nbsp;</td><td>是否为实物</td>	</tr>
	<tr class="Structure"><td>is_on_sale</td><td>tinyint(1) unsigned</td><td>否</td><td>1</td><td>&nbsp;</td><td>是否上架</td>	</tr>
	<tr class="Structure"><td>is_free_shipping</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>是否包邮0否1是</td>	</tr>
	<tr class="Structure"><td>on_time</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品上架时间</td>	</tr>
	<tr class="Structure"><td>sort</td><td>smallint(4) unsigned</td><td>否</td><td>50</td><td>&nbsp;</td><td>商品排序</td>	</tr>
	<tr class="Structure"><td>is_recommend</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>是否推荐</td>	</tr>
	<tr class="Structure"><td>is_new</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>是否新品</td>	</tr>
	<tr class="Structure"><td>is_hot</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否热卖</td>	</tr>
	<tr class="Structure"><td>last_update</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>最后更新时间</td>	</tr>
	<tr class="Structure"><td>goods_type</td><td>smallint(5) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品所属类型id，取值表goods_type的cat_id</td>	</tr>
	<tr class="Structure"><td>spec_type</td><td>smallint(5)</td><td>是</td><td>0</td><td>&nbsp;</td><td>商品规格类型，取值表goods_type的cat_id</td>	</tr>
	<tr class="Structure"><td>give_integral</td><td>mediumint(8)</td><td>是</td><td>0</td><td>&nbsp;</td><td>购买商品赠送积分</td>	</tr>
	<tr class="Structure"><td>exchange_integral</td><td>int(10)</td><td>否</td><td>0</td><td>&nbsp;</td><td>积分兑换：0不参与积分兑换，积分和现金的兑换比例见后台配置</td>	</tr>
	<tr class="Structure"><td>suppliers_id</td><td>smallint(5) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>供货商ID</td>	</tr>
	<tr class="Structure"><td>sales_sum</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>商品销量</td>	</tr>
	<tr class="Structure"><td>prom_type</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>0 普通订单,1 限时抢购, 2 团购 , 3 促销优惠</td>	</tr>
	<tr class="Structure"><td>prom_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>优惠活动id</td>	</tr>
	<tr class="Structure"><td>commission</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>佣金用于分销分成</td>	</tr>
	<tr class="Structure"><td>spu</td><td>varchar(128)</td><td>是</td><td></td><td>&nbsp;</td><td>SPU</td>	</tr>
	<tr class="Structure"><td>sku</td><td>varchar(128)</td><td>是</td><td></td><td>&nbsp;</td><td>SKU</td>	</tr>
	<tr class="Structure"><td>shipping_area_ids</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>配送物流shipping_area_id,以逗号分隔</td>	</tr>
</table><br>
<h2>表格: tp_goods_attr</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_goods_attr" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>goods_attr_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >attr_id</td><td>attr_id</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >goods_id</td><td>goods_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_goods_attr" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">goods_attr_id</td><td>int(10) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>商品属性id自增</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>attr_id</td><td>smallint(5) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>属性id</td>	</tr>
	<tr class="Structure"><td>attr_value</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>属性值</td>	</tr>
	<tr class="Structure"><td>attr_price</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>属性价格</td>	</tr>
</table><br>
<h2>表格: tp_goods_attribute</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_goods_attribute" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>attr_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >cat_id</td><td>type_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_goods_attribute" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">attr_id</td><td>int(11) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>属性id</td>	</tr>
	<tr class="Structure"><td>attr_name</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>属性名称</td>	</tr>
	<tr class="Structure"><td>type_id</td><td>smallint(5) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>属性分类id</td>	</tr>
	<tr class="Structure"><td>attr_index</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>0不需要检索 1关键字检索 2范围检索</td>	</tr>
	<tr class="Structure"><td>attr_type</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>0唯一属性 1单选属性 2复选属性</td>	</tr>
	<tr class="Structure"><td>attr_input_type</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td> 0 手工录入 1从列表中选择 2多行文本框</td>	</tr>
	<tr class="Structure"><td>attr_values</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>可选值列表</td>	</tr>
	<tr class="Structure"><td>order</td><td>tinyint(3) unsigned</td><td>否</td><td>50</td><td>&nbsp;</td><td>属性排序</td>	</tr>
</table><br>
<h2>表格: tp_goods_category</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_goods_category" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >parent_id</td><td>parent_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_goods_category" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>smallint(5) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>商品分类id</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(90)</td><td>否</td><td></td><td>utf8_bin</td><td>商品分类名称</td>	</tr>
	<tr class="Structure"><td>mobile_name</td><td>varchar(64)</td><td>是</td><td></td><td>utf8_bin</td><td>手机端显示的商品分类名</td>	</tr>
	<tr class="Structure"><td>parent_id</td><td>smallint(5) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>父id</td>	</tr>
	<tr class="Structure"><td>parent_id_path</td><td>varchar(128)</td><td>是</td><td></td><td>utf8_bin</td><td>家族图谱</td>	</tr>
	<tr class="Structure"><td>level</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>等级</td>	</tr>
	<tr class="Structure"><td>sort_order</td><td>tinyint(1) unsigned</td><td>否</td><td>50</td><td>&nbsp;</td><td>顺序排序</td>	</tr>
	<tr class="Structure"><td>is_show</td><td>tinyint(1) unsigned</td><td>否</td><td>1</td><td>&nbsp;</td><td>是否显示</td>	</tr>
	<tr class="Structure"><td>image</td><td>varchar(512)</td><td>是</td><td></td><td>utf8_bin</td><td>分类图片</td>	</tr>
	<tr class="Structure"><td>is_hot</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否推荐为热门分类</td>	</tr>
	<tr class="Structure"><td>cat_group</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>分类分组默认0</td>	</tr>
	<tr class="Structure"><td>commission_rate</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>分佣比例</td>	</tr>
</table><br>
<h2>表格: tp_goods_collect</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_goods_collect" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>collect_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >goods_id</td><td>goods_id</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >user_id</td><td>user_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_goods_collect" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">collect_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>add_time</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>添加时间</td>	</tr>
</table><br>
<h2>表格: tp_goods_consult</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_goods_consult" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_goods_consult" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>商品咨询id</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>username</td><td>varchar(32)</td><td>是</td><td></td><td>utf8</td><td>网名</td>	</tr>
	<tr class="Structure"><td>add_time</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>咨询时间</td>	</tr>
	<tr class="Structure"><td>consult_type</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>1 商品咨询 2 支付咨询 3 配送 4 售后</td>	</tr>
	<tr class="Structure"><td>content</td><td>varchar(1024)</td><td>是</td><td></td><td>utf8</td><td>咨询内容</td>	</tr>
	<tr class="Structure"><td>parent_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>父id 用于管理员回复</td>	</tr>
	<tr class="Structure"><td>is_show</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否显示</td>	</tr>
</table><br>
<h2>表格: tp_goods_images</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_goods_images" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>img_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >goods_id</td><td>goods_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_goods_images" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">img_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>图片id 自增</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>image_url</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>图片地址</td>	</tr>
</table><br>
<h2>表格: tp_goods_type</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_goods_type" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_goods_type" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>smallint(5) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>id自增</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>类型名称</td>	</tr>
</table><br>
<h2>表格: tp_group_buy</h2>
<p>备注: 团购商品表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_group_buy" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_group_buy" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(10) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>团购ID</td>	</tr>
	<tr class="Structure"><td>title</td><td>varchar(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>活动名称</td>	</tr>
	<tr class="Structure"><td>start_time</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>开始时间</td>	</tr>
	<tr class="Structure"><td>end_time</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>结束时间</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品ID</td>	</tr>
	<tr class="Structure"><td>price</td><td>numeric(10,2)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>团购价格</td>	</tr>
	<tr class="Structure"><td>goods_num</td><td>int(10)</td><td>是</td><td>0</td><td>&nbsp;</td><td>商品参团数</td>	</tr>
	<tr class="Structure"><td>buy_num</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品已购买数</td>	</tr>
	<tr class="Structure"><td>order_num</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>已下单人数</td>	</tr>
	<tr class="Structure"><td>virtual_num</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>虚拟购买数</td>	</tr>
	<tr class="Structure"><td>rebate</td><td>numeric(10,1)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>折扣</td>	</tr>
	<tr class="Structure"><td>intro</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>本团介绍</td>	</tr>
	<tr class="Structure"><td>goods_price</td><td>numeric(10,2)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>商品原价</td>	</tr>
	<tr class="Structure"><td>goods_name</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>商品名称</td>	</tr>
	<tr class="Structure"><td>recommended</td><td>tinyint(1) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>是否推荐 0.未推荐 1.已推荐</td>	</tr>
	<tr class="Structure"><td>views</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>查看次数</td>	</tr>
</table><br>
<h2>表格: tp_message</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_message" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>message_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_message" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">message_id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>admin_id</td><td>smallint(5) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>管理者id</td>	</tr>
	<tr class="Structure"><td>message</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>站内信内容</td>	</tr>
	<tr class="Structure"><td>type</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>个体消息：0，全体消息1</td>	</tr>
	<tr class="Structure"><td>category</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td> 系统消息：0，活动消息：1</td>	</tr>
	<tr class="Structure"><td>send_time</td><td>int(10) unsigned</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>发送时间</td>	</tr>
</table><br>
<h2>表格: tp_navigation</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_navigation" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_navigation" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>前台导航表</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(32)</td><td>是</td><td></td><td>utf8, utf8_bin</td><td>导航名称</td>	</tr>
	<tr class="Structure"><td>is_show</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>是否显示</td>	</tr>
	<tr class="Structure"><td>is_new</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>是否新窗口</td>	</tr>
	<tr class="Structure"><td>sort</td><td>smallint(6)</td><td>是</td><td>50</td><td>&nbsp;</td><td>排序</td>	</tr>
	<tr class="Structure"><td>url</td><td>varchar(255)</td><td>是</td><td></td><td>utf8, utf8_bin</td><td>链接地址</td>	</tr>
</table><br>
<h2>表格: tp_order</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_order" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>order_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >order_sn</td><td>order_sn</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >order_status</td><td>order_status</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >pay_id</td><td>pay_code</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >pay_status</td><td>pay_status</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >shipping_id</td><td>shipping_code</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >shipping_status</td><td>shipping_status</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >user_id</td><td>user_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_order" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">order_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>订单id</td>	</tr>
	<tr class="Structure"><td>order_sn</td><td>varchar(20)</td><td>否</td><td></td><td>&nbsp;</td><td>订单编号</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>order_status</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>订单状态</td>	</tr>
	<tr class="Structure"><td>shipping_status</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>发货状态</td>	</tr>
	<tr class="Structure"><td>pay_status</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>支付状态</td>	</tr>
	<tr class="Structure"><td>consignee</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>收货人</td>	</tr>
	<tr class="Structure"><td>country</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>国家</td>	</tr>
	<tr class="Structure"><td>province</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>省份</td>	</tr>
	<tr class="Structure"><td>city</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>城市</td>	</tr>
	<tr class="Structure"><td>district</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>县区</td>	</tr>
	<tr class="Structure"><td>twon</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>乡镇</td>	</tr>
	<tr class="Structure"><td>address</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>地址</td>	</tr>
	<tr class="Structure"><td>zipcode</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>邮政编码</td>	</tr>
	<tr class="Structure"><td>mobile</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>手机</td>	</tr>
	<tr class="Structure"><td>email</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>邮件</td>	</tr>
	<tr class="Structure"><td>shipping_code</td><td>varchar(32)</td><td>否</td><td>0</td><td>&nbsp;</td><td>物流code</td>	</tr>
	<tr class="Structure"><td>shipping_name</td><td>varchar(120)</td><td>否</td><td></td><td>&nbsp;</td><td>物流名称</td>	</tr>
	<tr class="Structure"><td>pay_code</td><td>varchar(32)</td><td>否</td><td></td><td>&nbsp;</td><td>支付code</td>	</tr>
	<tr class="Structure"><td>pay_name</td><td>varchar(120)</td><td>否</td><td></td><td>&nbsp;</td><td>支付方式名称</td>	</tr>
	<tr class="Structure"><td>invoice_title</td><td>varchar(256)</td><td>是</td><td></td><td>&nbsp;</td><td>发票抬头</td>	</tr>
	<tr class="Structure"><td>goods_price</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>商品总价</td>	</tr>
	<tr class="Structure"><td>shipping_price</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>邮费</td>	</tr>
	<tr class="Structure"><td>user_money</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>使用余额</td>	</tr>
	<tr class="Structure"><td>coupon_price</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>优惠券抵扣</td>	</tr>
	<tr class="Structure"><td>integral</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>使用积分</td>	</tr>
	<tr class="Structure"><td>integral_money</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>使用积分抵多少钱</td>	</tr>
	<tr class="Structure"><td>order_amount</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>应付款金额</td>	</tr>
	<tr class="Structure"><td>total_amount</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>订单总价</td>	</tr>
	<tr class="Structure"><td>add_time</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>下单时间</td>	</tr>
	<tr class="Structure"><td>shipping_time</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>最后新发货时间</td>	</tr>
	<tr class="Structure"><td>confirm_time</td><td>int(10)</td><td>是</td><td>0</td><td>&nbsp;</td><td>收货确认时间</td>	</tr>
	<tr class="Structure"><td>pay_time</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>支付时间</td>	</tr>
	<tr class="Structure"><td>order_prom_id</td><td>smallint(6)</td><td>否</td><td>0</td><td>&nbsp;</td><td>活动id</td>	</tr>
	<tr class="Structure"><td>order_prom_amount</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>活动优惠金额</td>	</tr>
	<tr class="Structure"><td>discount</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>价格调整</td>	</tr>
	<tr class="Structure"><td>user_note</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>用户备注</td>	</tr>
	<tr class="Structure"><td>admin_note</td><td>varchar(255)</td><td>是</td><td></td><td>&nbsp;</td><td>管理员备注</td>	</tr>
	<tr class="Structure"><td>parent_sn</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>父单单号</td>	</tr>
	<tr class="Structure"><td>is_distribut</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否已分成0未分成1已分成</td>	</tr>
</table><br>
<h2>表格: tp_order_action</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_order_action" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>action_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >order_id</td><td>order_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_order_action" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">action_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>order_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>订单ID</td>	</tr>
	<tr class="Structure"><td>action_user</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>操作人 0 为管理员操作</td>	</tr>
	<tr class="Structure"><td>order_status</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>订单状态</td>	</tr>
	<tr class="Structure"><td>shipping_status</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>配送状态</td>	</tr>
	<tr class="Structure"><td>pay_status</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>支付状态</td>	</tr>
	<tr class="Structure"><td>action_note</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>操作备注</td>	</tr>
	<tr class="Structure"><td>log_time</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>操作时间</td>	</tr>
	<tr class="Structure"><td>status_desc</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>状态描述</td>	</tr>
</table><br>
<h2>表格: tp_order_goods</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_order_goods" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>rec_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >goods_id</td><td>goods_id</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >order_id</td><td>order_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_order_goods" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">rec_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id自增</td>	</tr>
	<tr class="Structure"><td>order_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>订单id</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>goods_name</td><td>varchar(120)</td><td>否</td><td></td><td>&nbsp;</td><td>视频名称</td>	</tr>
	<tr class="Structure"><td>goods_sn</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>商品货号</td>	</tr>
	<tr class="Structure"><td>goods_num</td><td>smallint(5) unsigned</td><td>否</td><td>1</td><td>&nbsp;</td><td>购买数量</td>	</tr>
	<tr class="Structure"><td>market_price</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>市场价</td>	</tr>
	<tr class="Structure"><td>goods_price</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>本店价</td>	</tr>
	<tr class="Structure"><td>cost_price</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>商品成本价</td>	</tr>
	<tr class="Structure"><td>member_goods_price</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>会员折扣价</td>	</tr>
	<tr class="Structure"><td>give_integral</td><td>mediumint(8)</td><td>是</td><td>0</td><td>&nbsp;</td><td>购买商品赠送积分</td>	</tr>
	<tr class="Structure"><td>spec_key</td><td>varchar(128)</td><td>否</td><td></td><td>&nbsp;</td><td>商品规格key</td>	</tr>
	<tr class="Structure"><td>spec_key_name</td><td>varchar(128)</td><td>否</td><td></td><td>&nbsp;</td><td>规格对应的中文名字</td>	</tr>
	<tr class="Structure"><td>bar_code</td><td>varchar(64)</td><td>否</td><td></td><td>&nbsp;</td><td>条码</td>	</tr>
	<tr class="Structure"><td>is_comment</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否评价</td>	</tr>
	<tr class="Structure"><td>prom_type</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>0 普通订单,1 限时抢购, 2 团购 , 3 促销优惠</td>	</tr>
	<tr class="Structure"><td>prom_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>活动id</td>	</tr>
	<tr class="Structure"><td>is_send</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>0未发货，1已发货，2已换货，3已退货</td>	</tr>
	<tr class="Structure"><td>delivery_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>发货单ID</td>	</tr>
	<tr class="Structure"><td>sku</td><td>varchar(128)</td><td>是</td><td></td><td>&nbsp;</td><td>sku</td>	</tr>
</table><br>
<h2>表格: tp_payment</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_payment" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>pay_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >pay_code</td><td>pay_code</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_payment" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">pay_id</td><td>tinyint(3) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>pay_code</td><td>varchar(20)</td><td>否</td><td></td><td>&nbsp;</td><td>支付code</td>	</tr>
	<tr class="Structure"><td>pay_name</td><td>varchar(120)</td><td>否</td><td></td><td>&nbsp;</td><td>支付方式名称</td>	</tr>
	<tr class="Structure"><td>pay_fee</td><td>varchar(10)</td><td>否</td><td>0</td><td>&nbsp;</td><td>手续费</td>	</tr>
	<tr class="Structure"><td>pay_desc</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>描述</td>	</tr>
	<tr class="Structure"><td>pay_order</td><td>tinyint(3) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>pay_coder</td>	</tr>
	<tr class="Structure"><td>pay_config</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>配置</td>	</tr>
	<tr class="Structure"><td>enabled</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>开启</td>	</tr>
	<tr class="Structure"><td>is_cod</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>是否货到付款</td>	</tr>
	<tr class="Structure"><td>is_online</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>是否在线支付</td>	</tr>
</table><br>
<h2>表格: tp_pick_up</h2>
<p>备注: 自提点表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_pick_up" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>pickup_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_pick_up" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">pickup_id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>自提点id</td>	</tr>
	<tr class="Structure"><td>pickup_name</td><td>varchar(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>自提点名称</td>	</tr>
	<tr class="Structure"><td>pickup_address</td><td>varchar(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>自提点地址</td>	</tr>
	<tr class="Structure"><td>pickup_phone</td><td>varchar(30)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>自提点电话</td>	</tr>
	<tr class="Structure"><td>pickup_contact</td><td>varchar(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>自提点联系人</td>	</tr>
	<tr class="Structure"><td>province_id</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>省id</td>	</tr>
	<tr class="Structure"><td>city_id</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>市id</td>	</tr>
	<tr class="Structure"><td>district_id</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>区id</td>	</tr>
	<tr class="Structure"><td>suppliersid</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>供应商id</td>	</tr>
</table><br>
<h2>表格: tp_plugin</h2>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_plugin" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td>code</td><td>varchar(13)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>插件编码</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(55)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>中文名字</td>	</tr>
	<tr class="Structure"><td>version</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>插件的版本</td>	</tr>
	<tr class="Structure"><td>author</td><td>varchar(30)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>插件作者</td>	</tr>
	<tr class="Structure"><td>config</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>配置信息</td>	</tr>
	<tr class="Structure"><td>config_value</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>配置值信息</td>	</tr>
	<tr class="Structure"><td>desc</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>插件描述</td>	</tr>
	<tr class="Structure"><td>status</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否启用</td>	</tr>
	<tr class="Structure"><td>type</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>插件类型 payment支付 login 登陆 shipping物流</td>	</tr>
	<tr class="Structure"><td>icon</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>图标</td>	</tr>
	<tr class="Structure"><td>bank_code</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>网银配置信息</td>	</tr>
	<tr class="Structure"><td>scene</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>使用场景 0 PC+手机 1 手机 2 PC</td>	</tr>
</table><br>
<h2>表格: tp_prom_goods</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_prom_goods" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_prom_goods" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>活动ID</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(60)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>促销活动名称</td>	</tr>
	<tr class="Structure"><td>type</td><td>int(2)</td><td>否</td><td>0</td><td>&nbsp;</td><td>促销类型</td>	</tr>
	<tr class="Structure"><td>expression</td><td>varchar(100)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>优惠体现</td>	</tr>
	<tr class="Structure"><td>description</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>活动描述</td>	</tr>
	<tr class="Structure"><td>start_time</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>活动开始时间</td>	</tr>
	<tr class="Structure"><td>end_time</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>活动结束时间</td>	</tr>
	<tr class="Structure"><td>is_close</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>group</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>适用范围</td>	</tr>
	<tr class="Structure"><td>prom_img</td><td>varchar(150)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>活动宣传图片</td>	</tr>
</table><br>
<h2>表格: tp_prom_order</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_prom_order" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_prom_order" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(60)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>活动名称</td>	</tr>
	<tr class="Structure"><td>type</td><td>int(2)</td><td>否</td><td>0</td><td>&nbsp;</td><td>活动类型</td>	</tr>
	<tr class="Structure"><td>money</td><td>float(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>最小金额</td>	</tr>
	<tr class="Structure"><td>expression</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>优惠体现</td>	</tr>
	<tr class="Structure"><td>description</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>活动描述</td>	</tr>
	<tr class="Structure"><td>start_time</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>活动开始时间</td>	</tr>
	<tr class="Structure"><td>end_time</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>活动结束时间</td>	</tr>
	<tr class="Structure"><td>is_close</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>group</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>适用范围</td>	</tr>
</table><br>
<h2>表格: tp_rebate_log</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_rebate_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_rebate_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>分成记录表</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>获佣用户</td>	</tr>
	<tr class="Structure"><td>buy_user_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>购买人id</td>	</tr>
	<tr class="Structure"><td>nickname</td><td>varchar(32)</td><td>是</td><td></td><td>utf8_bin</td><td>购买人名称</td>	</tr>
	<tr class="Structure"><td>order_sn</td><td>varchar(32)</td><td>是</td><td></td><td>utf8_bin</td><td>订单编号</td>	</tr>
	<tr class="Structure"><td>order_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>订单id</td>	</tr>
	<tr class="Structure"><td>goods_price</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>订单商品总额</td>	</tr>
	<tr class="Structure"><td>money</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>获佣金额</td>	</tr>
	<tr class="Structure"><td>level</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>获佣用户级别</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>分成记录生成时间</td>	</tr>
	<tr class="Structure"><td>confirm</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>确定收货时间</td>	</tr>
	<tr class="Structure"><td>status</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>0未付款,1已付款, 2等待分成(已收货) 3已分成, 4已取消</td>	</tr>
	<tr class="Structure"><td>confirm_time</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>确定分成或者取消时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(1024)</td><td>是</td><td></td><td>utf8_bin</td><td>如果是取消, 有取消备注</td>	</tr>
</table><br>
<h2>表格: tp_recharge</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_recharge" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>order_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_recharge" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">order_id</td><td>bigint(20)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>bigint(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>会员ID</td>	</tr>
	<tr class="Structure"><td>nickname</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>会员昵称</td>	</tr>
	<tr class="Structure"><td>order_sn</td><td>varchar(30)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>充值单号</td>	</tr>
	<tr class="Structure"><td>account</td><td>float(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>充值金额</td>	</tr>
	<tr class="Structure"><td>ctime</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>充值时间</td>	</tr>
	<tr class="Structure"><td>pay_time</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>支付时间</td>	</tr>
	<tr class="Structure"><td>pay_code</td><td>varchar(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>pay_name</td><td>varchar(80)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>支付方式</td>	</tr>
	<tr class="Structure"><td>pay_status</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>充值状态0:待支付 1:充值成功 2:交易关闭</td>	</tr>
</table><br>
<h2>表格: tp_region</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_region" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_region" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(32)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>地区名称</td>	</tr>
	<tr class="Structure"><td>level</td><td>tinyint(4)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>地区等级 分省市县区</td>	</tr>
	<tr class="Structure"><td>parent_id</td><td>int(10)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>父id</td>	</tr>
</table><br>
<h2>表格: tp_region2</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_region2" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_region2" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>地区名称</td>	</tr>
	<tr class="Structure"><td>parent_id</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>父id</td>	</tr>
	<tr class="Structure"><td>level</td><td>tinyint(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>地区等级</td>	</tr>
</table><br>
<h2>表格: tp_remittance</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_remittance" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_remittance" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>分销用户转账记录表</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>汇款的用户id</td>	</tr>
	<tr class="Structure"><td>bank_name</td><td>varchar(32)</td><td>是</td><td></td><td>utf8_bin</td><td>收款银行名称</td>	</tr>
	<tr class="Structure"><td>account_bank</td><td>varchar(32)</td><td>是</td><td></td><td>utf8_bin</td><td>银行账号</td>	</tr>
	<tr class="Structure"><td>account_name</td><td>varchar(32)</td><td>是</td><td></td><td>utf8_bin</td><td>开户人名称</td>	</tr>
	<tr class="Structure"><td>money</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>汇款金额</td>	</tr>
	<tr class="Structure"><td>status</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>0汇款失败 1汇款成功</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>汇款时间</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(1024)</td><td>是</td><td></td><td>utf8_bin</td><td>汇款备注</td>	</tr>
	<tr class="Structure"><td>admin_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>管理员id</td>	</tr>
	<tr class="Structure"><td>withdrawals_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>提现申请表id</td>	</tr>
</table><br>
<h2>表格: tp_return_goods</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_return_goods" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_return_goods" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>退货申请表id自增</td>	</tr>
	<tr class="Structure"><td>order_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>订单id</td>	</tr>
	<tr class="Structure"><td>order_sn</td><td>varchar(1024)</td><td>是</td><td></td><td>utf8</td><td>订单编号</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>type</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>0退货1换货</td>	</tr>
	<tr class="Structure"><td>reason</td><td>varchar(1024)</td><td>是</td><td></td><td>utf8</td><td>退换货原因</td>	</tr>
	<tr class="Structure"><td>imgs</td><td>varchar(512)</td><td>是</td><td></td><td>utf8</td><td>拍照图片路径</td>	</tr>
	<tr class="Structure"><td>addtime</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>申请时间</td>	</tr>
	<tr class="Structure"><td>status</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>0申请中1客服理中2已完成</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(1024)</td><td>是</td><td></td><td>utf8</td><td>客服备注</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>spec_key</td><td>varchar(64)</td><td>是</td><td></td><td>utf8</td><td>商品规格key 对应tp_spec_goods_price 表</td>	</tr>
</table><br>
<h2>表格: tp_shipping</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_shipping" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>shipping_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >shipping_code</td><td>shipping_code, enabled</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_shipping" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">shipping_id</td><td>tinyint(3) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表 id</td>	</tr>
	<tr class="Structure"><td>shipping_code</td><td>varchar(20)</td><td>否</td><td></td><td>&nbsp;</td><td>快递代号</td>	</tr>
	<tr class="Structure"><td>shipping_name</td><td>varchar(120)</td><td>否</td><td></td><td>&nbsp;</td><td>快递名称</td>	</tr>
	<tr class="Structure"><td>shipping_desc</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>描述</td>	</tr>
	<tr class="Structure"><td>insure</td><td>varchar(10)</td><td>否</td><td>0</td><td>&nbsp;</td><td>保险</td>	</tr>
	<tr class="Structure"><td>enabled</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>是否开启</td>	</tr>
</table><br>
<h2>表格: tp_shipping_area</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_shipping_area" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>shipping_area_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >shipping_id</td><td>shipping_code</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_shipping_area" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">shipping_area_id</td><td>smallint(5) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>shipping_area_name</td><td>varchar(150)</td><td>否</td><td></td><td>&nbsp;</td><td>配送区域名称</td>	</tr>
	<tr class="Structure"><td>shipping_code</td><td>varchar(50)</td><td>否</td><td>0</td><td>&nbsp;</td><td>物流id</td>	</tr>
	<tr class="Structure"><td>config</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>配置首重续重等...序列化存储</td>	</tr>
	<tr class="Structure"><td>update_time</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>is_default</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否默认</td>	</tr>
</table><br>
<h2>表格: tp_sms_log</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_sms_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_sms_log" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>mobile</td><td>varchar(11)</td><td>是</td><td></td><td>&nbsp;</td><td>手机号</td>	</tr>
	<tr class="Structure"><td>session_id</td><td>varchar(128)</td><td>是</td><td></td><td>&nbsp;</td><td>session_id</td>	</tr>
	<tr class="Structure"><td>add_time</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>发送时间</td>	</tr>
	<tr class="Structure"><td>code</td><td>varchar(10)</td><td>是</td><td></td><td>&nbsp;</td><td>验证码</td>	</tr>
</table><br>
<h2>表格: tp_spec</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_spec" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_spec" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>规格表</td>	</tr>
	<tr class="Structure"><td>type_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>规格类型</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(55)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>规格名称</td>	</tr>
	<tr class="Structure"><td>order</td><td>int(11)</td><td>是</td><td>50</td><td>&nbsp;</td><td>排序</td>	</tr>
	<tr class="Structure"><td>search_index</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>是否需要检索：1是，0否</td>	</tr>
</table><br>
<h2>表格: tp_spec_goods_price</h2>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_spec_goods_price" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td>goods_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>key</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>utf8_bin</td><td>规格键名</td>	</tr>
	<tr class="Structure"><td>key_name</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>utf8_bin</td><td>规格键名中文</td>	</tr>
	<tr class="Structure"><td>price</td><td>numeric(10,2)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>价格</td>	</tr>
	<tr class="Structure"><td>store_count</td><td>int(11) unsigned</td><td>是</td><td>10</td><td>&nbsp;</td><td>库存数量</td>	</tr>
	<tr class="Structure"><td>bar_code</td><td>varchar(32)</td><td>是</td><td></td><td>utf8_bin</td><td>商品条形码</td>	</tr>
	<tr class="Structure"><td>sku</td><td>varchar(128)</td><td>是</td><td></td><td>utf8_bin</td><td>SKU</td>	</tr>
</table><br>
<h2>表格: tp_spec_image</h2>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_spec_image" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td>goods_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>商品规格图片表id</td>	</tr>
	<tr class="Structure"><td>spec_image_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>规格项id</td>	</tr>
	<tr class="Structure"><td>src</td><td>varchar(512)</td><td>是</td><td></td><td>utf8, utf8_bin</td><td>商品规格图片路径</td>	</tr>
</table><br>
<h2>表格: tp_spec_item</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_spec_item" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_spec_item" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>规格项id</td>	</tr>
	<tr class="Structure"><td>spec_id</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>规格id</td>	</tr>
	<tr class="Structure"><td>item</td><td>varchar(54)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>规格项</td>	</tr>
</table><br>
<h2>表格: tp_suppliers</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_suppliers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>suppliers_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_suppliers" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">suppliers_id</td><td>smallint(5) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>供应商ID</td>	</tr>
	<tr class="Structure"><td>suppliers_name</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>供应商名称</td>	</tr>
	<tr class="Structure"><td>suppliers_desc</td><td>mediumtext</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>供应商描述</td>	</tr>
	<tr class="Structure"><td>is_check</td><td>tinyint(1) unsigned</td><td>否</td><td>1</td><td>&nbsp;</td><td>供应商状态</td>	</tr>
	<tr class="Structure"><td>suppliers_contacts</td><td>varchar(255)</td><td>否</td><td></td><td>&nbsp;</td><td>供应商联系人</td>	</tr>
	<tr class="Structure"><td>suppliers_phone</td><td>varchar(20)</td><td>否</td><td></td><td>&nbsp;</td><td>供应商名字</td>	</tr>
</table><br>
<h2>表格: tp_system_menu</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_system_menu" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_system_menu" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>smallint(6) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>权限名字</td>	</tr>
	<tr class="Structure"><td>group</td><td>varchar(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>所属分组</td>	</tr>
	<tr class="Structure"><td>right</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>权限码(控制器+动作)</td>	</tr>
	<tr class="Structure"><td>is_del</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>删除状态 1删除,0正常</td>	</tr>
</table><br>
<h2>表格: tp_system_module</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_system_module" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>mod_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_system_module" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">mod_id</td><td>smallint(6) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>module</td><td>enum(top,menu,module)</td><td>是</td><td>module</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>level</td><td>tinyint(1)</td><td>是</td><td>3</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>ctl</td><td>varchar(20)</td><td>是</td><td></td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>act</td><td>varchar(30)</td><td>是</td><td></td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>title</td><td>varchar(20)</td><td>是</td><td></td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>visible</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>parent_id</td><td>smallint(6)</td><td>是</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>orderby</td><td>smallint(6)</td><td>是</td><td>50</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>icon</td><td>varchar(30)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
</table><br>
<h2>表格: tp_topic</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_topic" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>topic_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_topic" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">topic_id</td><td>int(10) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>topic_title</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>专题标题</td>	</tr>
	<tr class="Structure"><td>topic_image</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>专题封面</td>	</tr>
	<tr class="Structure"><td>topic_background_color</td><td>varchar(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>专题背景颜色</td>	</tr>
	<tr class="Structure"><td>topic_background</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>专题背景图</td>	</tr>
	<tr class="Structure"><td>topic_content</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>专题详情</td>	</tr>
	<tr class="Structure"><td>topic_repeat</td><td>varchar(20)</td><td>是</td><td></td><td>&nbsp;</td><td>背景重复方式</td>	</tr>
	<tr class="Structure"><td>topic_state</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>专题状态1-草稿、2-已发布</td>	</tr>
	<tr class="Structure"><td>topic_margin_top</td><td>tinyint(3)</td><td>是</td><td>0</td><td>&nbsp;</td><td>正文距顶部距离</td>	</tr>
	<tr class="Structure"><td>ctime</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>专题创建时间</td>	</tr>
</table><br>
<h2>表格: tp_user_address</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_user_address" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>address_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >user_id</td><td>user_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_user_address" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">address_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>consignee</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>收货人</td>	</tr>
	<tr class="Structure"><td>email</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>邮箱地址</td>	</tr>
	<tr class="Structure"><td>country</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>国家</td>	</tr>
	<tr class="Structure"><td>province</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>省份</td>	</tr>
	<tr class="Structure"><td>city</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>城市</td>	</tr>
	<tr class="Structure"><td>district</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>地区</td>	</tr>
	<tr class="Structure"><td>twon</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>乡镇</td>	</tr>
	<tr class="Structure"><td>address</td><td>varchar(120)</td><td>否</td><td></td><td>&nbsp;</td><td>地址</td>	</tr>
	<tr class="Structure"><td>zipcode</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>邮政编码</td>	</tr>
	<tr class="Structure"><td>mobile</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>手机</td>	</tr>
	<tr class="Structure"><td>is_default</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>默认收货地址</td>	</tr>
	<tr class="Structure"><td>is_pickup</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
</table><br>
<h2>表格: tp_user_level</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_user_level" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>level_id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_user_level" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">level_id</td><td>smallint(4) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>level_name</td><td>varchar(30)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>头衔名称</td>	</tr>
	<tr class="Structure"><td>amount</td><td>numeric(10,2)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>等级必要金额</td>	</tr>
	<tr class="Structure"><td>discount</td><td>smallint(4)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>折扣</td>	</tr>
	<tr class="Structure"><td>describe</td><td>varchar(200)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>头街 描述</td>	</tr>
</table><br>
<h2>表格: tp_user_message</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_user_message" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>rec_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >message_id</td><td>message_id</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >user_id</td><td>user_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_user_message" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">rec_id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>message_id</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>消息id</td>	</tr>
	<tr class="Structure"><td>category</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>系统消息0，活动消息</td>	</tr>
	<tr class="Structure"><td>status</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>查看状态：0未查看，1已查看</td>	</tr>
</table><br>
<h2>表格: tp_users</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_users" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>user_id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >email</td><td>email</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_users" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">user_id</td><td>mediumint(8) unsigned</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>email</td><td>varchar(60)</td><td>否</td><td></td><td>&nbsp;</td><td>邮件</td>	</tr>
	<tr class="Structure"><td>password</td><td>varchar(32)</td><td>否</td><td></td><td>&nbsp;</td><td>密码</td>	</tr>
	<tr class="Structure"><td>sex</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>0 保密 1 男 2 女</td>	</tr>
	<tr class="Structure"><td>birthday</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>生日</td>	</tr>
	<tr class="Structure"><td>user_money</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>用户金额</td>	</tr>
	<tr class="Structure"><td>frozen_money</td><td>numeric(10,2)</td><td>否</td><td>0.00</td><td>&nbsp;</td><td>冻结金额</td>	</tr>
	<tr class="Structure"><td>distribut_money</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>累积分佣金额</td>	</tr>
	<tr class="Structure"><td>pay_points</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>消费积分</td>	</tr>
	<tr class="Structure"><td>address_id</td><td>mediumint(8) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>默认收货地址</td>	</tr>
	<tr class="Structure"><td>reg_time</td><td>int(10) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>注册时间</td>	</tr>
	<tr class="Structure"><td>last_login</td><td>int(11) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>最后登录时间</td>	</tr>
	<tr class="Structure"><td>last_ip</td><td>varchar(15)</td><td>否</td><td></td><td>&nbsp;</td><td>最后登录ip</td>	</tr>
	<tr class="Structure"><td>qq</td><td>varchar(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>QQ</td>	</tr>
	<tr class="Structure"><td>mobile</td><td>varchar(20)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>手机号码</td>	</tr>
	<tr class="Structure"><td>mobile_validated</td><td>tinyint(3) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>是否验证手机</td>	</tr>
	<tr class="Structure"><td>oauth</td><td>varchar(10)</td><td>是</td><td></td><td>&nbsp;</td><td>第三方来源 wx weibo alipay</td>	</tr>
	<tr class="Structure"><td>openid</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>第三方唯一标示</td>	</tr>
	<tr class="Structure"><td>head_pic</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>头像</td>	</tr>
	<tr class="Structure"><td>province</td><td>int(6)</td><td>是</td><td>0</td><td>&nbsp;</td><td>省份</td>	</tr>
	<tr class="Structure"><td>city</td><td>int(6)</td><td>是</td><td>0</td><td>&nbsp;</td><td>市区</td>	</tr>
	<tr class="Structure"><td>district</td><td>int(6)</td><td>是</td><td>0</td><td>&nbsp;</td><td>县</td>	</tr>
	<tr class="Structure"><td>email_validated</td><td>tinyint(1) unsigned</td><td>否</td><td>0</td><td>&nbsp;</td><td>是否验证电子邮箱</td>	</tr>
	<tr class="Structure"><td>nickname</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>第三方返回昵称</td>	</tr>
	<tr class="Structure"><td>level</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>会员等级</td>	</tr>
	<tr class="Structure"><td>discount</td><td>numeric(10,2)</td><td>是</td><td>1.00</td><td>&nbsp;</td><td>会员折扣，默认1不享受</td>	</tr>
	<tr class="Structure"><td>total_amount</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>消费累计额度</td>	</tr>
	<tr class="Structure"><td>is_lock</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否被锁定冻结</td>	</tr>
	<tr class="Structure"><td>is_distribut</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>是否为分销商 0 否 1 是</td>	</tr>
	<tr class="Structure"><td>first_leader</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>第一个上级</td>	</tr>
	<tr class="Structure"><td>second_leader</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>第二个上级</td>	</tr>
	<tr class="Structure"><td>third_leader</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>第三个上级</td>	</tr>
	<tr class="Structure"><td>token</td><td>varchar(64)</td><td>是</td><td></td><td>&nbsp;</td><td>用于app 授权类似于session_id</td>	</tr>
</table><br>
<h2>表格: tp_withdrawals</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_withdrawals" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_withdrawals" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>提现申请表</td>	</tr>
	<tr class="Structure"><td>user_id</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>申请日期</td>	</tr>
	<tr class="Structure"><td>money</td><td>numeric(10,2)</td><td>是</td><td>0.00</td><td>&nbsp;</td><td>提现金额</td>	</tr>
	<tr class="Structure"><td>bank_name</td><td>varchar(32)</td><td>是</td><td></td><td>utf8_bin</td><td>银行名称 如支付宝 微信 中国银行 农业银行等</td>	</tr>
	<tr class="Structure"><td>account_bank</td><td>varchar(32)</td><td>是</td><td></td><td>utf8_bin</td><td>银行账号</td>	</tr>
	<tr class="Structure"><td>account_name</td><td>varchar(32)</td><td>是</td><td></td><td>utf8_bin</td><td>银行账户名 可以是支付宝可以其他银行</td>	</tr>
	<tr class="Structure"><td>remark</td><td>varchar(1024)</td><td>是</td><td></td><td>utf8_bin</td><td>提现备注</td>	</tr>
	<tr class="Structure"><td>status</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>提现状态0申请中1申请成功2申请失败</td>	</tr>
</table><br>
<h2>表格: tp_wx_img</h2>
<p>备注: 微信图文</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_wx_img" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_wx_img" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>keyword</td><td>char(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>关键词</td>	</tr>
	<tr class="Structure"><td>desc</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>简介</td>	</tr>
	<tr class="Structure"><td>pic</td><td>char(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>封面图片</td>	</tr>
	<tr class="Structure"><td>url</td><td>char(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>图文外链地址</td>	</tr>
	<tr class="Structure"><td>createtime</td><td>varchar(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>uptatetime</td><td>varchar(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>token</td><td>char(30)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>token</td>	</tr>
	<tr class="Structure"><td>title</td><td>varchar(60)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>标题</td>	</tr>
	<tr class="Structure"><td>goods_id</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>商品id</td>	</tr>
	<tr class="Structure"><td>goods_name</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>商品名称</td>	</tr>
</table><br>
<h2>表格: tp_wx_keyword</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_wx_keyword" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >pid</td><td>pid</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >token</td><td>token</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_wx_keyword" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>keyword</td><td>char(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>关键词</td>	</tr>
	<tr class="Structure"><td>pid</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>对应表ID</td>	</tr>
	<tr class="Structure"><td>token</td><td>varchar(60)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>token</td>	</tr>
	<tr class="Structure"><td>type</td><td>varchar(30)</td><td>是</td><td>TEXT</td><td>&nbsp;</td><td>关键词操作类型</td>	</tr>
</table><br>
<h2>表格: tp_wx_menu</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_wx_menu" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_wx_menu" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>id</td>	</tr>
	<tr class="Structure"><td>level</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>菜单级别</td>	</tr>
	<tr class="Structure"><td>name</td><td>varchar(50)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>name</td>	</tr>
	<tr class="Structure"><td>sort</td><td>int(5)</td><td>是</td><td>0</td><td>&nbsp;</td><td>排序</td>	</tr>
	<tr class="Structure"><td>type</td><td>varchar(20)</td><td>是</td><td></td><td>&nbsp;</td><td>0 view 1 click</td>	</tr>
	<tr class="Structure"><td>value</td><td>varchar(255)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>value</td>	</tr>
	<tr class="Structure"><td>token</td><td>varchar(50)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>token</td>	</tr>
	<tr class="Structure"><td>pid</td><td>int(11)</td><td>是</td><td>0</td><td>&nbsp;</td><td>上级菜单</td>	</tr>
</table><br>
<h2>表格: tp_wx_msg</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_wx_msg" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>msgid</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >createymd</td><td>sendtime</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >fake_id</td><td>titile</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >uid</td><td>admin_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_wx_msg" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">msgid</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>admin_id</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>系统用户ID</td>	</tr>
	<tr class="Structure"><td>titile</td><td>varchar(100)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>content</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>createtime</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>sendtime</td><td>int(11)</td><td>否</td><td>0</td><td>&nbsp;</td><td>发送时间</td>	</tr>
	<tr class="Structure"><td>issend</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>0未发送1成功2失败</td>	</tr>
	<tr class="Structure"><td>sendtype</td><td>tinyint(1)</td><td>是</td><td>1</td><td>&nbsp;</td><td>0单人1所有</td>	</tr>
</table><br>
<h2>表格: tp_wx_news</h2>
<p>备注: 微信图文</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_wx_news" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_wx_news" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>keyword</td><td>char(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>keyword</td>	</tr>
	<tr class="Structure"><td>createtime</td><td>varchar(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>uptatetime</td><td>varchar(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>token</td><td>char(30)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>token</td>	</tr>
	<tr class="Structure"><td>img_id</td><td>varchar(50)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>图文组合id</td>	</tr>
</table><br>
<h2>表格: tp_wx_text</h2>
<p>备注: 文本回复表</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_wx_text" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >uid</td><td>uid</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_wx_text" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>uid</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>用户id</td>	</tr>
	<tr class="Structure"><td>uname</td><td>varchar(90)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>用户名</td>	</tr>
	<tr class="Structure"><td>keyword</td><td>char(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>关键词</td>	</tr>
	<tr class="Structure"><td>precisions</td><td>tinyint(1)</td><td>否</td><td>0</td><td>&nbsp;</td><td>precisions</td>	</tr>
	<tr class="Structure"><td>text</td><td>text</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>text</td>	</tr>
	<tr class="Structure"><td>createtime</td><td>varchar(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>创建时间</td>	</tr>
	<tr class="Structure"><td>updatetime</td><td>varchar(13)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>更新时间</td>	</tr>
	<tr class="Structure"><td>click</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>点击</td>	</tr>
	<tr class="Structure"><td>token</td><td>char(30)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>token</td>	</tr>
</table><br>
<h2>表格: tp_wx_user</h2>
<p>备注: 微信公共帐号</p>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="tp_wx_user" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >uid</td><td>uid</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >uid_2</td><td>uid</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="tp_wx_user" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>表id</td>	</tr>
	<tr class="Structure"><td>uid</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>uid</td>	</tr>
	<tr class="Structure"><td>wxname</td><td>varchar(60)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>公众号名称</td>	</tr>
	<tr class="Structure"><td>aeskey</td><td>varchar(256)</td><td>否</td><td></td><td>&nbsp;</td><td>aeskey</td>	</tr>
	<tr class="Structure"><td>encode</td><td>tinyint(1)</td><td>否</td><td>0</td><td>&nbsp;</td><td>encode</td>	</tr>
	<tr class="Structure"><td>appid</td><td>varchar(50)</td><td>否</td><td></td><td>&nbsp;</td><td>appid</td>	</tr>
	<tr class="Structure"><td>appsecret</td><td>varchar(50)</td><td>否</td><td></td><td>&nbsp;</td><td>appsecret</td>	</tr>
	<tr class="Structure"><td>wxid</td><td>varchar(64)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>公众号原始ID</td>	</tr>
	<tr class="Structure"><td>weixin</td><td>char(64)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>微信号</td>	</tr>
	<tr class="Structure"><td>headerpic</td><td>char(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>头像地址</td>	</tr>
	<tr class="Structure"><td>token</td><td>char(255)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>token</td>	</tr>
	<tr class="Structure"><td>w_token</td><td>varchar(150)</td><td>否</td><td></td><td>&nbsp;</td><td>微信对接token</td>	</tr>
	<tr class="Structure"><td>create_time</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>create_time</td>	</tr>
	<tr class="Structure"><td>updatetime</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>updatetime</td>	</tr>
	<tr class="Structure"><td>tplcontentid</td><td>varchar(2)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>内容模版ID</td>	</tr>
	<tr class="Structure"><td>share_ticket</td><td>varchar(150)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>分享ticket</td>	</tr>
	<tr class="Structure"><td>share_dated</td><td>char(15)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>share_dated</td>	</tr>
	<tr class="Structure"><td>authorizer_access_token</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>authorizer_access_token</td>	</tr>
	<tr class="Structure"><td>authorizer_refresh_token</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>authorizer_refresh_token</td>	</tr>
	<tr class="Structure"><td>authorizer_expires</td><td>char(10)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>authorizer_expires</td>	</tr>
	<tr class="Structure"><td>type</td><td>tinyint(1)</td><td>否</td><td>0</td><td>&nbsp;</td><td>类型</td>	</tr>
	<tr class="Structure"><td>web_access_token</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td> 网页授权token</td>	</tr>
	<tr class="Structure"><td>web_refresh_token</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>web_refresh_token</td>	</tr>
	<tr class="Structure"><td>web_expires</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>过期时间</td>	</tr>
	<tr class="Structure"><td>qr</td><td>varchar(200)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>qr</td>	</tr>
	<tr class="Structure"><td>menu_config</td><td>text</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>菜单</td>	</tr>
	<tr class="Structure"><td>wait_access</td><td>tinyint(1)</td><td>是</td><td>0</td><td>&nbsp;</td><td>微信接入状态,0待接入1已接入</td>	</tr>
</table><br>
</body>
</html>
